Panduit Wire Terminations Dialog

Lets you to format and create the final Wire Termination report output that will include the termination information.

Accessed when:

You select the Output button in the Wire Terminations dialog.

The Panduit gauge check program will read your connection list and based on maximum and minimum gauges entered into your parts database, it will report any wires that are oversized or undersized.

Create Tab

Setting	Description
Output rile	Enter the path and filename for the output file that will be created by the export tool.
Output format	Enter the path and filename of a formatting file that specifies the structure of the export file. A large variety of formats are possible.
Header file	Enter the path and filename for the header file. A header file is a text file that serves as a heading to create column names in the output file.
Gauge Check	Reads your connection list and based on maximum and minimum gauges entered into your parts database, it will report any wires that are oversized or undersized. This can be especially useful for catching sizing errors on devices like fuses or motors which have a minimum gauge requirement or component that have a physical limit on wire size. For this function to work properly you must have the connection point texts for all of your parts entered into the parts database and the Gauge range. The file will display any wires listed in the shortest distance connection list that are outside of the range specified in the parts database. If connection point data is missing from the parts database it will also display an error.
Assign Terminations	Creates an MDB file of the assigned connection information. This file is created as an intermediate step so that you may manually or automatically modify the results before the final output.
Update BOM	Sends all of the assigned terminations to the project's Bill of Materials. Any terminations previously written to the project are first deleted.
Post Process	Allows you to write custom code to manipulate the Access database used to temporarily store the connection information. Selecting this button will run any EXE file named POST_PROCESS.EXE, which must be created by the user and placed in the PanduitDataEditor folder inside the Plugins folder of your Substation installation.
Create	Creates the specified output file.

File Format Tab

The File Format tab is used to structure and filter the information in the exported file. The formatting tool allows you to select all of the connection information from Substation and place it into a file in the format that you need. The tool will allow for creation of comma-separated files, fixed field width files, XML files, INI files and many other formats. It will also provide lookup capabilities. For example, a spool number can be assigned to a wire based on its gauge and color.

The tab is used to format the information for one wire. When the output file is created, the format is used over and over for each wire. The dialog also allows the user to filter out certain wires or to have them sorted with up to 15 nested sorts.

Select each variable and use the up and down arrow buttons to put the variables in the order needed for the export file. A line at the bottom of the dialog displays a sample line of output.

Note: At the very bottom of the field listings is a field for Komax. Placing a Y in the Use field will place a wire quantity and unique article name in each new file. This is required when exporting to a Komax wire cutting machine.

Setting	Description
Field	Shows all of the data available from Substation for the export file. Wire Number - Wire number seq. Wire Number - A sequential number starting at 1 for each wire in the output file. SD Wire Number - A sequential number applied to each wire coming from the shortest distance file. Wire Color - Wire Color Wire Gauge - Wire Gauge Length - Length calculated by shortest distance routing From Strip Length - From Strip length assigned from parts database To Strip Length - To Strip length assigned from parts database Diameter (Use lookup 1) - From the first value in the lookup table Type (Use lookup 2) - From the second value in the lookup table Part Number (Use lookup 3) - From the third value in the lookup table From Terminator Part number To Terminator Part number From Installation - From device installation name From Location - From device location name From ID - Device tag of the From Device From Connection Point - From Device connection point text Full ID:CP From Full - From Device ID with CP text To Installation - To device installation name To Location - To device location name To ID - Device tag of the To Device To Connection Point - From Device connection point text Full ID:CP To Full - To Device ID with CP text Wire Attribute 1 to 5 - Five user wire attributes From Terminator - From Terminator description assigned by program To Terminator - To Terminator description assigned by program Komax header - When "Y" is in the Use field, creates a file header suitable for Komax wire cutting machines. Error - Connection which could not be terminated because of missing part numbers or missing connection point information in the database connection point information will have the word error in this field. Using a filter value of error will filter out these wires. From Location lookup - The lookup value associated with the from location name To Location lookup - The lookup value associated with the to location name Branch Number - A sequential number starting with 1 that is assigned to each existing wire number within a potential Use - The Use assigned in the wire numbering dialog Voltage - Voltage assigned in the wire numbering dialog Current - Current assigned in the wire numbering dialog Part Number - Part Number assigned in the wire numbering dialog Type - Type assigned in the wire numbering dialog Cable Installation - Installation of cable to which wire is assigned Cable Location - Location of cable to which wire is assigned Cable ID - ID of cable to which wire is assigned Cable Family - Family of cable to which wire is assigned Cable Type - Type of cable to which wire is assigned Cable Length - Length of cable to which wire is assigned Cable Conductor - Conductor of cable to which wire is assigned Cable Part Number - Part Number of cable to which wire is assigned Cable Gauge - Gauge of cable to which wire is assigned Wire Attribute 6 - 10 - Additional user attributes assigned to wire
Use	Select which fields you will want in the export file. A Y will appear for all variables that are selected to be exported (click again to remove the Y).
Fixed Width	If a variable is supposed to use a specific number of characters, place the field width in the Fixed Width column. Entries that are too long will be truncated to this number and entries that are too small will be padded with extra spaces.
Prefix	For constant text that should be output before the value of the variable. For a comma separated file the lead text would be " (a single quote) for the first variable and "," (quote comma quote) for the remaining variables. For an XML or INI file format you would put in the label for the variable.
Suffix	For fixed text to place after the value of a variable. A ^ character should be used to specify that a new line should be inserted.
Sup, If from = to	Suppresses the installation and location variables when wires are routed entirely within a given installation/location.
Sup. Prefix	Allows the = + - characters to be suppressed from the complete device ID (=installation+location-device tag).
Sort	Enter a number from 1 to 15 to specify levels of sorting in the file. 15 levels of filtering are supported.
New File	Specifies if a new file should be created when the value for this variable change. For example if you set part number to have the sort value of 1 and set the new file option, you will get a separate export file with each wire part number. The additional files will use the user specified output file name with a sequential number appended to the end. If you wish to use this option, click inside the field so that a Y appears.
Swap	Used for one value in the Field column. It will swap all from and to values based on what is alphanumerically higher in this field. This is most often used for swapping based on the terminator field so that a wire would have an "A" termination on the from side and the B termination on the to side. Without the use of the swap toggle, half of the wires would have an A termination on the from side and roughly half would have a B termination on the from. The result would be setting up the machine twice as often as required. If you wish to use this option, click inside the field so that a Y appears. This toggle should be used for only one field.
Prioritize	Causes the from and to to be temporarily swapped based on which value is higher in the prioritized field. This is only done to properly evaluate sorting and does not physically change the output of the individual lines as the Swap option does. This would typically be used for the from installation sort. If installations were named A through D, setting the prioritize and sort for from installation would insure that all wires within, or leaving installation A, were together. Without the prioritize option selected, wire from installation A to D would appear near the top of the sort and wires from D to A would appear near the bottom. Using the prioritize option allows the actual wiring to occur in a more orderly fashion.
Filter	Allows removal of records from the export. The entered values will be used for exclusion. For example: entering SH,6,8,10 in the Filter column for Gauge would exclude all records with a gauge of SH, 6, 8 or 10. Values should be comma separated and will be used as a string comparison with the exception of the Length field. A filter in the Length field will eliminate all records with a length shorter than the entered number.
Sup. Field if empty	Suppress everything on that line if the variable has no value.
Delete	Deletes duplicated fields from the format.
Duplicate	Places a variable more than once. This may be used when one end of the wire is to be labeled with the to-from targets and the other end of the wire is to receive the from-to targets.
Save	Saves the settings to a specific file name or load already created files for further editing.

Wire Lookups Tab

The Wire Lookups tab enables you to assign new values to wires based on existing values entered into Substation. This could be done to select a wire number based on gauge and color or a strip length based on wire gauge.

Lookup values allow you to specify values in the export file based on a combination of wire variable. For example, a color and gauge can be used to specify the part number for a specific wire spool. The gauge can be used to specify the wire diameter. This avoids having to fill these values into the wire attributes on every wire. However, if the values cannot be determined from a simple lookup, you may need to use wire attributes and place data on every wire. For example, if you require Outside Diameter and you are using two different types of wire, Gauge alone would not be enough to determine the correct diameter to use. You would have to use one of the wire attributes to specify wire type, when you create your schematics.

Setting	Description
Lookup 1	Enter the values and the corresponding wire attributes.
Lookup 2	Enter the values and the corresponding wire attributes.
Lookup 3	Enter the values and the corresponding wire attributes.
Save	Saves the changes.

Location Lookups Tab

The Location Lookups tab allow locations to be sorted in a non-alphanumeric sequence. Location Lookup Values allow you to modify sorting based on location. Normally all sorts are alphanumeric. If you have set location names and want to create wires in a non-alphanumeric sort, by entering lookup values for the set location names a non-alphanumeric sort can be achieved. For example: locations could be named for sub-panels within the enclosures. The locations names may be TOP, LEFT, MAIN, RIGHT, DOOR, and BOTTOM. With a normal alphanumeric sort the wires would be sorted in the order BOTTOM, DOOR, LEFT, MAIN, RIGHT, TOP. If users want the wires for the Door to be listed first and then the main panel, they can enter the location names in the Location Lookup dialog and enter a lookup value of A next to the DOOR and B next to the MAIN, etc. The wire sort will now list wires in location DOOR at the top and then location MAIN.

Setting	Description
Location	Enter the names of the locations.
Lookup Value	Place letters that when sorted alphanumerically will put the corresponding locations in the desired order.
Save	Saves the changes.